package com.zc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zc.pojo.Scores;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * @author zc
 * @Date 2025/8/22
 * @apiNote
 */
@Mapper
public interface ScoreStatsMapper extends BaseMapper<Scores> {

    /**
     * 查询指定考试每个班级的基础统计数据
     */
    List<Map<String, Object>> getClassBasicStats(@Param("examId") Integer examId);

    /**
     * 查询指定考试每个学生的成绩，用于计算积分和分数段
     */
    List<Map<String, Object>> getStudentScoresByExam(@Param("examId") Integer examId);
}